Ascend 2024

Oracle Database 23ai Free Version with “App Simple” features is now available in production mode for the developer community. Developers and data engineers now have access to innovative features that simplify development of modern and cloud data-driven applications. Right around the corner, Oracle Database 23ai Long-Term Support Release will be available in Oracle Cloud, to Engineered Systems and to on-premises customers.

Learning Objective 1: This session will prepare you for the upgrade path to Oracle Database 23ai as we discuss: why should you consider making this upgrade strategy a part of your data strategy.

Learning Objective 2: Why should you consider adopting the new features of Oracle Database 23ai.

Learning Objective 3: The multi-tenant option is critical to upgrading to Oracle Database 23ai. If you have not embraced it yet, what are the things that you need to factor in as part of the upgrade.

Oracle Database 23ai in Oracle Cloud introduces a rich array of innovative features aimed at enhancing the developer experience, simplifying application development, and empowering data professionals to work more efficiently with cutting-edge AI and ML capabilities. During our session, we will explore the top 5 AI/ML features, examining their potential applications and benefits. Additionally, we will discuss strategies and best practices for migrating your database and applications to Oracle Cloud Infrastructure (OCI), ensuring a seamless transition to leverage these advanced features and capabilities.

Learning Objective 1: Generative AI Integration: Enhances experiences by seamlessly incorporating generative AI, including vector support and large language models (LLMs).

Learning Objective 2: AI Vector Search & Low-Code Integration: Oracle Database 23ai simplifies generative AI in apps, extends to low-code platforms for ease of development.

Learning Objective 3: Natural Language to SQL Generation: Introduces the capability to query data using natural language in the Autonomous Database, combining generative Al with SQL.

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

Learning Objective 1: What tools are available for deep diving into a SQL statement?

Learning Objective 2: When would you use each of these tools, and how do you understand the output?

Learning Objective 3: What are some of the ways to force the Optimizer to behave the way I want it to?